2012-08-20 - 4804.100 - Spec - License Scorecard #CrystalReportDevelopment

SPECIFICATIONS

4804.100 - License Scorecard

Requirement Summary

---

Need to design and develop License Scorecard Crystal Report.

Admin Info

---

Purpose	Need to develop License Scorecard report.
Requested By	Mark Harris
Spec Created By	Mallareddy D
Spec Created Date	08/20/2012
Spec QA by	Uday Kumar P
Objects	SA140
Document Status	Complete

References

---

Prior Tickets

None

Documents

None

Functional Requirement

---

1) Report needs to show the grouping as Region > Sales Org > License.
2) Report needs to show this year Shipped revenue YTD, Open revenue YTD, Total Revenue YTD, Last Year Shipped Revenue YTD, Shipped % Last Year and Total % Last Year. This needs to be shown in Top left corner side of the report.
3) Report with same info mentioned in point 2 need to show only for hot market in top right corner of the report.
4) Total Revenue YTD = Shipped Revenue YTD + Open Revenue YTD.
5) LY Shipped YTD % = Actual Revenue Shipped Current YTD/ Last Year Total Revenue * 100
6) LY Shipped Year % = Actual Revenue Current Year/ Last Year Total Revenue * 100.
7) Total LY YTD % = Current Year Total YTD Revenue / Last Year Total Revenue * 100.
8) Total LY Year % = Current Year Toal Revenue / Last Year Total Revenue * 100.
9) Report need to show Shipped Collection, Open Collection, Shipped Product Lines, Open Product Lines, Shipped Product Styles, Open Product Styles, Shipped Customer and Shipped Concessionaire.
10) Report needs to show Current Year Revenue, Current Year Quantity, Previous Year Quantity and Previous Year Revenue for all the sections mentioned in point 9.
11) Along with above definition, report needs to show service level information.
12) Service level information includes Ordered Ontime, Ordered Fill Rate, Confirmed Ontime, Confirmed Fill Rate and First Pass.
13) All KPI's mentioned in point 12 needs to show the information for Current Year and Previous Year.

Solution Summary

---

1. Need to create BEx queries as per report requirements.
2. Need to use the queries in reports as appropriate.

Test Plan

SNo.	Test Scenario	Expected Results
1.	Need to check the report values with BEx query	Values should be identical.
2.	Check report against the Crystal reports standards	Report should pass all expected standards.

Solution Details

---

1) Need to create BEx queries according to the report requirement.
2) Need to include the developed BEx queries in reports to achieve the functional requirement.

Issues

---

None